﻿CREATE TABLE [dbo].[Estudiante] (
    [IdEstudiante]    INT IDENTITY (1, 1) NOT NULL,
    [IdPersona]       INT NOT NULL,
    [IdCurso]         INT NOT NULL,
    [IdRepresentante] INT NOT NULL,
    CONSTRAINT [PK_Estudiante] PRIMARY KEY CLUSTERED ([IdEstudiante] ASC),
    CONSTRAINT [FK_PersonaEstudiante] FOREIGN KEY ([IdPersona]) REFERENCES [dbo].[Persona] ([IdPersona]),
    CONSTRAINT [FK_Representante] FOREIGN KEY ([IdRepresentante]) REFERENCES [dbo].[Persona] ([IdPersona])
);

